XIQS Get Rotation Logs List

getXIQSRotLogList ( [ Long id_partition ] , [ filter f ] )

Get Rotation Logs from current partition (all for admin).

One record corresponds to one Sim rotation (from allocation to release).
Record is created when Sim is allocated to the device with relevant values (startxxx fields). Unknown values are set to zero (including stopdate).
In normal case, all other values are set when Device aknowledge Sim Release (stopxxx fileds, including stop date).
After that record will never be updated and will be deleted after 60 days by default.

There are exceptions to that process:
- When Device is shut down, it will never acknowledge the Sim Release and record will never be closed. Currently, the only solution to delete these records is database manual deletion.
- When Sim is automatically released on Device Disconnection Timer (which is defined in Allocation rule), stop values are set. Data usage might be updated when the Device reconnects and sends its last consumed bytes.
- When End Time of Day Pass is reached, Data usage is updated with current Device value. Again, data usage might be updated when the Device reconnects and sends its last consumed bytes.

[ Long id_partition ]

id partition for filtering on a partition (admin only)

[ filter f ]

Long id - Rotation Log Id


String version - SIM Activity log version number


Long id_partition - Partition ID


String iccid - SIM card ICCID


String imsi - SIM card IMSI


String operatorname - SIM card name of the operator


String country - SIM card name of the country


String devicename - Name of the GSM device in use


String deviceip - IP Address of the GSM device in use


Integer deviceport - Port number of the GSM device in use


Long startdate - Start date & time of the SIM card allocation


Long stopdate - Stop date & time of the SIM card allocation (SIM card release date & time)


Long startcredit - Remaining minutes value at the start of the SIM card allocation


Long stopcredit - Remaining minutes value at the stop of the SIM card allocation (SIM card release)


String ppname - Name of the SIM Plan in use


String allocrulename - Name of the Allocation Rule in use


Long stopcause - Value of the STOP cause, see table below


Long callnb - Number of calls (connected or not) during the SIM card allocation period of time


Long asr - ASR during the SIM card allocation period of time (0 to 100%)


Long acd - ACD during the SIM card allocation period of time (in seconds)


Long transaction - Number of transactions done on the SIM card during the allocation period of time, with format like XXXYYYZZZ:

XXX : number of Activation transactions

YYY : number of transactions

ZZZ : number of Credit Check transactions


Long startsmscredit - Remaining number of SMS at the start of the SIM card allocation


Long stopsmscredit - Remaining number of SMS at the stop of the SIM card allocation (SIM card release)


Long smsnb - Number of SMS sent during the allocation period of time


Long smserrornb - Number of SMS Sending Errors during the allocation period of time


String deviceserial - Serial Number of the GSM device in use


Long startdatausage - Remaining Data at the start of the SIM card allocation


Long stopdatausage - Remaining Data at the stop of the SIM card allocation (SIM card release)


Long datausage - Data consume during the allocation period of time


Integer m2state - Highest status reached by the MIFI indicates what was the last registration status of the device

0 : Device has connected with no sim or waiting for Virtual SIM.

1 : Sim has been initialized (data received from Rack)

3 : Sim has been registered to Network

8 : Sim allocation is being processed

9 : Sim stayed in Not Registered state

25: Sim Array has been disconnected

Error Data structure ( Error Management )

Possible failure code returns
 *ERR_SRV_INTERNAL (500) ERR_MSG_NO_DB
   

getXIQSRotLogReport